---
title: DB-CLL-064 — Validate a state code (non-parameterized — flagged)
summary: Validate a state code (non-parameterized — flagged)
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-064 — Validate a state code (non-parameterized — flagged)

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-064 |
| Operation type | R |
| Execution method | Text |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Inline text SQL |
| Business object | clsOtherFirm.ValidateState |
| Criteria property | n/a (custom method) |
| Lifecycle method | n/a |

## Parameters

No bound parameters were identified for this statement.

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [ALL_STATES](../database-tables.md#all_states) | SELECT | STATE (concatenated, not bound) |

## Sample SQL

```sql
Select
  Count(*)
From
  ALL_STATES
Where
  STATE = '<State value concatenated directly into SQL text - not a bind parameter>'
```

## Operations and processes

- [Manage attorney and legal-person reference data](../operations/manage-attorney-and-legal-person.md)

## Business rules

- [BR-CLM-LGL-006](../business-rules.md#br-clm-lgl-006-attorney-policy-assignment-requires-a-valid-policy)
- [BR-CLM-LGL-007](../business-rules.md#br-clm-lgl-007-attorney-policy-assignment-requires-a-primary-attorney)
- [BR-CLM-LGL-008](../business-rules.md#br-clm-lgl-008-attorney-profile-requires-attorney%2C-type%2C-and-valid-date-range)
- [BR-CLM-LGL-009](../business-rules.md#br-clm-lgl-009-duplicate-attorney-profile-rows-are-rejected)
- [BR-CLM-LGL-010](../business-rules.md#br-clm-lgl-010-attorney-schedule-entry-requires-attorney%2C-reason%2C-and-duration)
- [BR-CLM-LGL-011](../business-rules.md#br-clm-lgl-011-attorney-schedule-dates-must-be-valid-and-non-past)
- [BR-CLM-LGL-014](../business-rules.md#br-clm-lgl-014-legal-person-requires-last-and-first-name)
- [BR-CLM-LGL-015](../business-rules.md#br-clm-lgl-015-legal-person-cannot-be-deleted-while-referenced)
- [BR-CLM-LGL-016](../business-rules.md#br-clm-lgl-016-legal-person-type-link-requires-person-and-type-code)
- [BR-CLM-LGL-017](../business-rules.md#br-clm-lgl-017-other-firm-state-city-must-be-valid)
- [BR-CLM-LGL-018](../business-rules.md#br-clm-lgl-018-out-of-town-rotation-assignment-dates-must-be-valid-and-non-past)

> **Note:** Statements marked with `*` were inferred from code structure, naming
> conventions, or contextual evidence where direct confirmation was not available
> in source artifacts. Statements marked with `**` could not be confirmed; treat
> as unknown until verified.

## Sources

- `SAIF.Business.Claim.Legal\TableMaint\clsOtherFirm.vb`